﻿CREATE VIEW [dbo].[ASMS_V_ServiceItem]
	AS 
SELECT SI.*,
	SC.Name as CategoryName
FROM ASMS_ServiceItem as SI
	left join ASMS_ServiceCategory as SC on SC.Id = SI.CategoryId
